Dataset statistics
| Number of variables | 32 |
|---|---|
| Number of observations | 85895 |
| Missing cells | 556929 |
| Missing cells (%) | 20.3% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 21.0 MiB |
| Average record size in memory | 256.0 B |
Variable types
| Categorical | 20 |
|---|---|
| Numeric | 11 |
| Boolean | 1 |
ID has a high cardinality: 85895 distinct values | High cardinality |
LEGAL NAME has a high cardinality: 38744 distinct values | High cardinality |
DOING BUSINESS AS NAME has a high cardinality: 41686 distinct values | High cardinality |
ADDRESS has a high cardinality: 42146 distinct values | High cardinality |
CITY has a high cardinality: 1223 distinct values | High cardinality |
STATE has a high cardinality: 54 distinct values | High cardinality |
ZIP CODE has a high cardinality: 1710 distinct values | High cardinality |
WARD PRECINCT has a high cardinality: 2383 distinct values | High cardinality |
LICENSE DESCRIPTION has a high cardinality: 106 distinct values | High cardinality |
APPLICATION CREATED DATE has a high cardinality: 2899 distinct values | High cardinality |
APPLICATION REQUIREMENTS COMPLETE has a high cardinality: 3078 distinct values | High cardinality |
PAYMENT DATE has a high cardinality: 4356 distinct values | High cardinality |
LICENSE TERM START DATE has a high cardinality: 2825 distinct values | High cardinality |
LICENSE TERM EXPIRATION DATE has a high cardinality: 297 distinct values | High cardinality |
LICENSE APPROVED FOR ISSUANCE has a high cardinality: 4223 distinct values | High cardinality |
DATE ISSUED has a high cardinality: 3498 distinct values | High cardinality |
LICENSE STATUS CHANGE DATE has a high cardinality: 3152 distinct values | High cardinality |
LOCATION has a high cardinality: 21388 distinct values | High cardinality |
LICENSE ID is highly correlated with LICENSE NUMBER | High correlation |
ACCOUNT NUMBER is highly correlated with LICENSE NUMBER | High correlation |
WARD is highly correlated with POLICE DISTRICT and 1 other fields | High correlation |
POLICE DISTRICT is highly correlated with WARD and 1 other fields | High correlation |
LICENSE NUMBER is highly correlated with LICENSE ID and 1 other fields | High correlation |
LATITUDE is highly correlated with WARD and 1 other fields | High correlation |
ACCOUNT NUMBER is highly correlated with LICENSE NUMBER | High correlation |
WARD is highly correlated with LATITUDE | High correlation |
POLICE DISTRICT is highly correlated with LATITUDE | High correlation |
LICENSE NUMBER is highly correlated with ACCOUNT NUMBER | High correlation |
LATITUDE is highly correlated with WARD and 1 other fields | High correlation |
ACCOUNT NUMBER is highly correlated with LICENSE NUMBER | High correlation |
WARD is highly correlated with LATITUDE | High correlation |
POLICE DISTRICT is highly correlated with LATITUDE | High correlation |
LICENSE NUMBER is highly correlated with ACCOUNT NUMBER | High correlation |
LATITUDE is highly correlated with WARD and 1 other fields | High correlation |
LICENSE ID is highly correlated with ACCOUNT NUMBER and 1 other fields | High correlation |
ACCOUNT NUMBER is highly correlated with LICENSE ID and 1 other fields | High correlation |
WARD is highly correlated with POLICE DISTRICT and 3 other fields | High correlation |
PRECINCT is highly correlated with LICENSE STATUS | High correlation |
POLICE DISTRICT is highly correlated with WARD and 2 other fields | High correlation |
LICENSE NUMBER is highly correlated with LICENSE ID and 1 other fields | High correlation |
SSA is highly correlated with WARD and 3 other fields | High correlation |
LATITUDE is highly correlated with WARD and 3 other fields | High correlation |
LONGITUDE is highly correlated with WARD and 2 other fields | High correlation |
LICENSE STATUS is highly correlated with PRECINCT | High correlation |
WARD has 49701 (57.9%) missing values | Missing |
PRECINCT has 56701 (66.0%) missing values | Missing |
WARD PRECINCT has 49700 (57.9%) missing values | Missing |
POLICE DISTRICT has 54012 (62.9%) missing values | Missing |
APPLICATION CREATED DATE has 64660 (75.3%) missing values | Missing |
PAYMENT DATE has 1289 (1.5%) missing values | Missing |
LICENSE APPROVED FOR ISSUANCE has 6789 (7.9%) missing values | Missing |
LICENSE STATUS CHANGE DATE has 55400 (64.5%) missing values | Missing |
SSA has 76446 (89.0%) missing values | Missing |
LATITUDE has 47246 (55.0%) missing values | Missing |
LONGITUDE has 47246 (55.0%) missing values | Missing |
LOCATION has 47246 (55.0%) missing values | Missing |
ID is uniformly distributed | Uniform |
ID has unique values | Unique |
LICENSE ID has unique values | Unique |
Reproduction
| Analysis started | 2021-11-13 16:55:37.902570 |
|---|---|
| Analysis finished | 2021-11-13 16:56:51.565959 |
| Duration | 1 minute and 13.66 seconds |
| Software version | pandas-profiling v3.1.0 |
| Download configuration | config.json |
| Distinct | 85895 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 671.2 KiB |
| 35342-20020816 | 1 |
|---|---|
| 1980206-20090702 | 1 |
| 1305775-20030221 | 1 |
| 19008-20050216 | 1 |
| 1648907-20061116 | 1 |
| Other values (85890) |
Length
| Max length | 16 |
|---|---|
| Median length | 16 |
| Mean length | 15.45860644 |
| Min length | 5 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 85895 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 35342-20020816 |
|---|---|
| 2nd row | 1358463-20051116 |
| 3rd row | 1980233-20090722 |
| 4th row | 1476582-20040211 |
| 5th row | 1141408-20080516 |
Common Values
| Value | Count | Frequency (%) |
| 35342-20020816 | 1 | < 0.1% |
| 1980206-20090702 | 1 | < 0.1% |
| 1305775-20030221 | 1 | < 0.1% |
| 19008-20050216 | 1 | < 0.1% |
| 1648907-20061116 | 1 | < 0.1% |
| 2054042-20120916 | 1 | < 0.1% |
| 78942-20020216 | 1 | < 0.1% |
| 1899451-20080415 | 1 | < 0.1% |
| 73978-20020216 | 1 | < 0.1% |
| 1171106-20020816 | 1 | < 0.1% |
| Other values (85885) | 85885 |
Length
| Value | Count | Frequency (%) |
| 35342-20020816 | 1 | < 0.1% |
| 1249744-20090316 | 1 | < 0.1% |
| 1476582-20040211 | 1 | < 0.1% |
| 1141408-20080516 | 1 | < 0.1% |
| 2129534-20111129 | 1 | < 0.1% |
| 1275083-20040216 | 1 | < 0.1% |
| 1223497-20030816 | 1 | < 0.1% |
| 1222096-20020124 | 1 | < 0.1% |
| 1197714-20020809 | 1 | < 0.1% |
| 1170778-20070216 | 1 | < 0.1% |
| Other values (85885) | 85885 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 85895 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1751302.855 |
| Minimum | 30793 |
|---|---|
| Maximum | 2456551 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 671.2 KiB |
Quantile statistics
| Minimum | 30793 |
|---|---|
| 5-th percentile | 1218939.6 |
| Q1 | 1469024.5 |
| median | 1778754 |
| Q3 | 2067578.5 |
| 95-th percentile | 2196172.7 |
| Maximum | 2456551 |
| Range | 2425758 |
| Interquartile range (IQR) | 598554 |
Descriptive statistics
| Standard deviation | 335877.9915 |
|---|---|
| Coefficient of variation (CV) | 0.1917874972 |
| Kurtosis | -0.2276203254 |
| Mean | 1751302.855 |
| Median Absolute Deviation (MAD) | 297695 |
| Skewness | -0.2802107113 |
| Sum | 1.504281588 × 1011 |
| Variance | 1.128140251 × 1011 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1256593 | 1 | < 0.1% |
| 1980206 | 1 | < 0.1% |
| 1305775 | 1 | < 0.1% |
| 1554456 | 1 | < 0.1% |
| 1758312 | 1 | < 0.1% |
| 2176585 | 1 | < 0.1% |
| 1200182 | 1 | < 0.1% |
| 1899451 | 1 | < 0.1% |
| 1208866 | 1 | < 0.1% |
| 1268667 | 1 | < 0.1% |
| Other values (85885) | 85885 |
| Value | Count | Frequency (%) |
| 30793 | 1 | |
| 41719 | 1 | |
| 48969 | 1 | |
| 53118 | 1 | |
| 53183 | 1 | |
| 53209 | 1 | |
| 61874 | 1 | |
| 62889 | 1 | |
| 67988 | 1 | |
| 68113 | 1 |
| Value | Count | Frequency (%) |
| 2456551 | 1 | |
| 2456537 | 1 | |
| 2456485 | 1 | |
| 2456429 | 1 | |
| 2456375 | 1 | |
| 2456351 | 1 | |
| 2456335 | 1 | |
| 2456002 | 1 | |
| 2455929 | 1 | |
| 2455678 | 1 |
ACCOUNT NUMBER
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 38897 |
|---|---|
| Distinct (%) | 45.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 196695.4217 |
| Minimum | 10 |
|---|---|
| Maximum | 397444 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 671.2 KiB |
Quantile statistics
| Minimum | 10 |
|---|---|
| 5-th percentile | 15383 |
| Q1 | 54615 |
| median | 248313 |
| Q3 | 300243.5 |
| 95-th percentile | 364316.8 |
| Maximum | 397444 |
| Range | 397434 |
| Interquartile range (IQR) | 245628.5 |
Descriptive statistics
| Standard deviation | 126819.3438 |
|---|---|
| Coefficient of variation (CV) | 0.6447498506 |
| Kurtosis | -1.541581426 |
| Mean | 196695.4217 |
| Median Absolute Deviation (MAD) | 95058 |
| Skewness | -0.2698652744 |
| Sum | 1.689515325 × 1010 |
| Variance | 1.608314595 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 65406 | 689 | 0.8% |
| 29087 | 164 | 0.2% |
| 201168 | 94 | 0.1% |
| 63414 | 87 | 0.1% |
| 243206 | 82 | 0.1% |
| 25415 | 75 | 0.1% |
| 147 | 74 | 0.1% |
| 55050 | 74 | 0.1% |
| 11071 | 73 | 0.1% |
| 85325 | 72 | 0.1% |
| Other values (38887) | 84411 |
| Value | Count | Frequency (%) |
| 10 | 2 | < 0.1% |
| 12 | 1 | < 0.1% |
| 13 | 5 | |
| 33 | 4 | < 0.1% |
| 44 | 4 | < 0.1% |
| 49 | 1 | < 0.1% |
| 50 | 2 | < 0.1% |
| 54 | 10 | |
| 57 | 2 | < 0.1% |
| 62 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 397444 | 1 | |
| 396371 | 1 | |
| 392821 | 1 | |
| 392577 | 1 | |
| 382494 | 1 | |
| 381614 | 1 | |
| 378184 | 1 | |
| 377938 | 1 | |
| 377933 | 1 | |
| 377918 | 1 |
SITE NUMBER
Real number (ℝ≥0)
| Distinct | 177 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.556027708 |
| Minimum | 1 |
|---|---|
| Maximum | 417 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 671.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 5 |
| Maximum | 417 |
| Range | 416 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 8.655706391 |
|---|---|
| Coefficient of variation (CV) | 3.386389891 |
| Kurtosis | 221.046802 |
| Mean | 2.556027708 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 12.14917818 |
| Sum | 219550 |
| Variance | 74.92125313 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 61478 | |
| 2 | 13721 | 16.0% |
| 3 | 4869 | 5.7% |
| 4 | 1431 | 1.7% |
| 5 | 629 | 0.7% |
| 6 | 347 | 0.4% |
| 7 | 296 | 0.3% |
| 8 | 258 | 0.3% |
| 10 | 187 | 0.2% |
| 9 | 183 | 0.2% |
| Other values (167) | 2496 | 2.9% |
| Value | Count | Frequency (%) |
| 1 | 61478 | |
| 2 | 13721 | 16.0% |
| 3 | 4869 | 5.7% |
| 4 | 1431 | 1.7% |
| 5 | 629 | 0.7% |
| 6 | 347 | 0.4% |
| 7 | 296 | 0.3% |
| 8 | 258 | 0.3% |
| 9 | 183 | 0.2% |
| 10 | 187 | 0.2% |
| Value | Count | Frequency (%) |
| 417 | 1 | |
| 307 | 1 | |
| 242 | 1 | |
| 237 | 1 | |
| 215 | 1 | |
| 188 | 1 | |
| 187 | 1 | |
| 185 | 1 | |
| 183 | 1 | |
| 181 | 2 |
| Distinct | 38744 |
|---|---|
| Distinct (%) | 45.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 671.2 KiB |
| WASTE MANAGEMENT OF ILLINOIS INC. | 689 |
|---|---|
| GROOT RECYCLING & WASTE SERVICES, INC. | 164 |
| SUPREME CATERING COMPANY | 94 |
| STARBUCKS CORPORATION | 87 |
| ALLIED WASTE TRANSPORTATION INC. | 82 |
| Other values (38739) |
Length
| Max length | 110 |
|---|---|
| Median length | 21 |
| Mean length | 21.96154607 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 25019 ? |
|---|---|
| Unique (%) | 29.1% |
Sample
| 1st row | CARMEN CAHUE |
|---|---|
| 2nd row | ISLA TROPICAL, INC. |
| 3rd row | DJS REMODELING |
| 4th row | ALL-BRY CONSTRUCTION CO. |
| 5th row | MCDONOUGH MECHANICAL SERVICE |
Common Values
| Value | Count | Frequency (%) |
| WASTE MANAGEMENT OF ILLINOIS INC. | 689 | 0.8% |
| GROOT RECYCLING & WASTE SERVICES, INC. | 164 | 0.2% |
| SUPREME CATERING COMPANY | 94 | 0.1% |
| STARBUCKS CORPORATION | 87 | 0.1% |
| ALLIED WASTE TRANSPORTATION INC. | 82 | 0.1% |
| ROY STROM REFUSE INC | 75 | 0.1% |
| GROOT, INC. | 74 | 0.1% |
| WALGREEN CO. | 74 | 0.1% |
| FAMILY DOLLAR, INC. | 73 | 0.1% |
| AMERICAN DRUG STORES LLC | 72 | 0.1% |
| Other values (38734) | 84411 |
Length
| Value | Count | Frequency (%) |
| inc | 35858 | 12.1% |
| 9700 | 3.3% | |
| llc | 5834 | 2.0% |
| construction | 5493 | 1.9% |
| co | 3613 | 1.2% |
| services | 3055 | 1.0% |
| a | 2293 | 0.8% |
| heating | 2262 | 0.8% |
| company | 2134 | 0.7% |
| corp | 2102 | 0.7% |
| Other values (28417) | 222852 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 41686 |
|---|---|
| Distinct (%) | 48.5% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 671.2 KiB |
| WASTE MANAGEMENT METRO | 610 |
|---|---|
| GROOT RECYCLING & WASTE SERVICES, INC. | 88 |
| ROY STROM REFUSE | 75 |
| CROWN RECYCLING & WASTE SERVICES, INC. | 74 |
| SUPREME CATERING, INC | 67 |
| Other values (41681) |
Length
| Max length | 87 |
|---|---|
| Median length | 21 |
| Mean length | 21.53520618 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 27812 ? |
|---|---|
| Unique (%) | 32.4% |
Sample
| 1st row | CLAUDIA'S BRIDAL SHOP |
|---|---|
| 2nd row | ISLA TROPICAL |
| 3rd row | DJS REMODELING, INC. |
| 4th row | ALL-BRY CONSTRUCTION CO. |
| 5th row | MCDONOUGH MECHANICAL SERVICE |
Common Values
| Value | Count | Frequency (%) |
| WASTE MANAGEMENT METRO | 610 | 0.7% |
| GROOT RECYCLING & WASTE SERVICES, INC. | 88 | 0.1% |
| ROY STROM REFUSE | 75 | 0.1% |
| CROWN RECYCLING & WASTE SERVICES, INC. | 74 | 0.1% |
| SUPREME CATERING, INC | 67 | 0.1% |
| GROOT RECYCLING AND WASTE SERVICES, INC. | 58 | 0.1% |
| PHILLIP'S ICE CREAM | 51 | 0.1% |
| GROEN WASTE SERVICE | 50 | 0.1% |
| LAND AND LAKES DISPOSAL SERVICES | 49 | 0.1% |
| JACKSON HEWITT TAX SERVICE | 42 | < 0.1% |
| Other values (41676) | 84730 |
Length
| Value | Count | Frequency (%) |
| inc | 24376 | 8.5% |
| 12538 | 4.4% | |
| construction | 7283 | 2.5% |
| co | 3852 | 1.3% |
| heating | 3490 | 1.2% |
| services | 3422 | 1.2% |
| llc | 3254 | 1.1% |
| and | 2604 | 0.9% |
| service | 2297 | 0.8% |
| a | 2113 | 0.7% |
| Other values (27622) | 221483 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 42146 |
|---|---|
| Distinct (%) | 49.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 671.2 KiB |
| 1500 N HOOKER ST | 537 |
|---|---|
| 2500 LANDMEIER RD | 147 |
| 3800 LARAMIE AVE 2 | 108 |
| 1900 MAYWOOD RD | 74 |
| 21900 S CENTRAL | 55 |
| Other values (42141) |
Length
| Max length | 49 |
|---|---|
| Median length | 18 |
| Mean length | 18.62718435 |
| Min length | 7 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 28096 ? |
|---|---|
| Unique (%) | 32.7% |
Sample
| 1st row | 2625 S CENTRAL PARK AVE 1 |
|---|---|
| 2nd row | 2825 W MONTROSE AVE |
| 3rd row | 1605 CLAVEY RD 1 |
| 4th row | 8 NORTH TRAIL |
| 5th row | 4081 JOSEPH DR |
Common Values
| Value | Count | Frequency (%) |
| 1500 N HOOKER ST | 537 | 0.6% |
| 2500 LANDMEIER RD | 147 | 0.2% |
| 3800 LARAMIE AVE 2 | 108 | 0.1% |
| 1900 MAYWOOD RD | 74 | 0.1% |
| 21900 S CENTRAL | 55 | 0.1% |
| 1201 GREENWOOD AVE | 55 | 0.1% |
| 13701 S KOSTNER | 53 | 0.1% |
| 2608 S DAMEN AVE | 51 | 0.1% |
| 4612 W LAKE ST | 50 | 0.1% |
| 700 E GRAND AVE | 49 | 0.1% |
| Other values (42136) | 84716 |
Length
| Value | Count | Frequency (%) |
| ave | 29984 | 8.3% |
| w | 22499 | 6.2% |
| st | 20370 | 5.6% |
| s | 16681 | 4.6% |
| n | 16516 | 4.6% |
| 1st | 15499 | 4.3% |
| 1 | 9731 | 2.7% |
| rd | 8420 | 2.3% |
| dr | 6231 | 1.7% |
| e | 4667 | 1.3% |
| Other values (15944) | 211512 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 1223 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 671.2 KiB |
| CHICAGO | |
|---|---|
| CICERO | 1248 |
| SKOKIE | 1219 |
| DES PLAINES | 1047 |
| ELK GROVE | 752 |
| Other values (1218) |
Length
| Max length | 21 |
|---|---|
| Median length | 7 |
| Mean length | 8.371267245 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 337 ? |
|---|---|
| Unique (%) | 0.4% |
Sample
| 1st row | CHICAGO |
|---|---|
| 2nd row | CHICAGO |
| 3rd row | HIGHLAND |
| 4th row | LEMONT |
| 5th row | WAUKEGAN |
Common Values
| Value | Count | Frequency (%) |
| CHICAGO | 36744 | |
| CICERO | 1248 | 1.5% |
| SKOKIE | 1219 | 1.4% |
| DES PLAINES | 1047 | 1.2% |
| ELK GROVE | 752 | 0.9% |
| GLENVIEW | 738 | 0.9% |
| NILES | 725 | 0.8% |
| ARLINGTON HEIGHTS | 664 | 0.8% |
| NORTHBROOK | 635 | 0.7% |
| SOUTH HOLLAND | 618 | 0.7% |
| Other values (1213) | 41505 |
Length
| Value | Count | Frequency (%) |
| chicago | 37458 | |
| park | 5812 | 5.5% |
| grove | 2263 | 2.1% |
| heights | 1561 | 1.5% |
| oak | 1374 | 1.3% |
| cicero | 1248 | 1.2% |
| skokie | 1219 | 1.1% |
| des | 1049 | 1.0% |
| plaines | 1047 | 1.0% |
| hills | 1014 | 1.0% |
| Other values (1144) | 52175 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 54 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 671.2 KiB |
| IL | |
|---|---|
| IN | 1749 |
| WI | 547 |
| CA | 354 |
| MI | 350 |
| Other values (49) | 2349 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 6 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | IL |
|---|---|
| 2nd row | IL |
| 3rd row | IL |
| 4th row | IL |
| 5th row | IL |
Common Values
| Value | Count | Frequency (%) |
| IL | 80546 | |
| IN | 1749 | 2.0% |
| WI | 547 | 0.6% |
| CA | 354 | 0.4% |
| MI | 350 | 0.4% |
| NY | 218 | 0.3% |
| OH | 191 | 0.2% |
| TX | 167 | 0.2% |
| MO | 165 | 0.2% |
| MN | 141 | 0.2% |
| Other values (44) | 1467 | 1.7% |
Length
| Value | Count | Frequency (%) |
| il | 80546 | |
| in | 1749 | 2.0% |
| wi | 547 | 0.6% |
| ca | 354 | 0.4% |
| mi | 350 | 0.4% |
| ny | 218 | 0.3% |
| oh | 191 | 0.2% |
| tx | 167 | 0.2% |
| mo | 165 | 0.2% |
| mn | 141 | 0.2% |
| Other values (44) | 1467 | 1.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 1710 |
|---|---|
| Distinct (%) | 2.0% |
| Missing | 31 |
| Missing (%) | < 0.1% |
| Memory size | 671.2 KiB |
| 60618 | 1738 |
|---|---|
| 60647 | 1680 |
| 60622 | 1411 |
| 60639 | 1361 |
| 60608 | 1265 |
| Other values (1705) |
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 4.996692444 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 569 ? |
|---|---|
| Unique (%) | 0.7% |
Sample
| 1st row | 60623 |
|---|---|
| 2nd row | 60618 |
| 3rd row | 60035 |
| 4th row | 60439 |
| 5th row | 60087 |
Common Values
| Value | Count | Frequency (%) |
| 60618 | 1738 | 2.0% |
| 60647 | 1680 | 2.0% |
| 60622 | 1411 | 1.6% |
| 60639 | 1361 | 1.6% |
| 60608 | 1265 | 1.5% |
| 60632 | 1243 | 1.4% |
| 60804 | 1222 | 1.4% |
| 60609 | 1222 | 1.4% |
| 60611 | 1221 | 1.4% |
| 60623 | 1028 | 1.2% |
| Other values (1700) | 72473 |
Length
| Value | Count | Frequency (%) |
| 60618 | 1738 | 2.0% |
| 60647 | 1680 | 2.0% |
| 60622 | 1411 | 1.6% |
| 60639 | 1361 | 1.6% |
| 60608 | 1265 | 1.5% |
| 60632 | 1243 | 1.4% |
| 60804 | 1222 | 1.4% |
| 60609 | 1222 | 1.4% |
| 60611 | 1221 | 1.4% |
| 60623 | 1028 | 1.2% |
| Other values (1700) | 72473 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 50 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 49701 |
| Missing (%) | 57.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28.52892745 |
| Minimum | 1 |
|---|---|
| Maximum | 50 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 671.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 17 |
| median | 30 |
| Q3 | 42 |
| 95-th percentile | 47 |
| Maximum | 50 |
| Range | 49 |
| Interquartile range (IQR) | 25 |
Descriptive statistics
| Standard deviation | 13.92170978 |
|---|---|
| Coefficient of variation (CV) | 0.4879857401 |
| Kurtosis | -1.010474819 |
| Mean | 28.52892745 |
| Median Absolute Deviation (MAD) | 12 |
| Skewness | -0.3821678344 |
| Sum | 1032576 |
| Variance | 193.8140031 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 42 | 4497 | 5.2% |
| 27 | 1906 | 2.2% |
| 25 | 1431 | 1.7% |
| 35 | 1049 | 1.2% |
| 47 | 968 | 1.1% |
| 30 | 930 | 1.1% |
| 33 | 918 | 1.1% |
| 32 | 904 | 1.1% |
| 12 | 900 | 1.0% |
| 2 | 897 | 1.0% |
| Other values (40) | 21794 | |
| (Missing) | 49701 |
| Value | Count | Frequency (%) |
| 1 | 702 | |
| 2 | 897 | |
| 3 | 468 | |
| 4 | 473 | |
| 5 | 308 | 0.4% |
| 6 | 384 | |
| 7 | 281 | 0.3% |
| 8 | 470 | |
| 9 | 291 | 0.3% |
| 10 | 649 |
| Value | Count | Frequency (%) |
| 50 | 592 | 0.7% |
| 49 | 442 | 0.5% |
| 48 | 573 | 0.7% |
| 47 | 968 | 1.1% |
| 46 | 461 | 0.5% |
| 45 | 818 | 1.0% |
| 44 | 875 | 1.0% |
| 43 | 679 | 0.8% |
| 42 | 4497 | |
| 41 | 673 | 0.8% |
| Distinct | 76 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 56701 |
| Missing (%) | 66.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.63297253 |
| Minimum | 1 |
|---|---|
| Maximum | 999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 671.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 12 |
| median | 26 |
| Q3 | 41 |
| 95-th percentile | 61 |
| Maximum | 999 |
| Range | 998 |
| Interquartile range (IQR) | 29 |
Descriptive statistics
| Standard deviation | 163.1749551 |
|---|---|
| Coefficient of variation (CV) | 2.986748617 |
| Kurtosis | 29.21323813 |
| Mean | 54.63297253 |
| Median Absolute Deviation (MAD) | 14 |
| Skewness | 5.555225013 |
| Sum | 1594955 |
| Variance | 26626.06599 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 9 | 1566 | 1.8% |
| 999 | 838 | 1.0% |
| 6 | 684 | 0.8% |
| 7 | 675 | 0.8% |
| 14 | 672 | 0.8% |
| 28 | 670 | 0.8% |
| 12 | 653 | 0.8% |
| 21 | 624 | 0.7% |
| 15 | 582 | 0.7% |
| 20 | 575 | 0.7% |
| Other values (66) | 21655 | 25.2% |
| (Missing) | 56701 |
| Value | Count | Frequency (%) |
| 1 | 465 | 0.5% |
| 2 | 423 | 0.5% |
| 3 | 480 | 0.6% |
| 4 | 435 | 0.5% |
| 5 | 516 | 0.6% |
| 6 | 684 | |
| 7 | 675 | |
| 8 | 526 | 0.6% |
| 9 | 1566 | |
| 10 | 513 | 0.6% |
| Value | Count | Frequency (%) |
| 999 | 838 | |
| 76 | 1 | < 0.1% |
| 74 | 6 | < 0.1% |
| 73 | 8 | < 0.1% |
| 72 | 15 | < 0.1% |
| 71 | 6 | < 0.1% |
| 70 | 10 | < 0.1% |
| 69 | 37 | < 0.1% |
| 68 | 155 | 0.2% |
| 67 | 52 | 0.1% |
| Distinct | 2383 |
|---|---|
| Distinct (%) | 6.6% |
| Missing | 49700 |
| Missing (%) | 57.9% |
| Memory size | 671.2 KiB |
| 42- | 1448 |
|---|---|
| 42-9 | 1139 |
| 27- | 834 |
| 25- | 468 |
| 35-999 | 455 |
| Other values (2378) |
Length
| Max length | 6 |
|---|---|
| Median length | 5 |
| Mean length | 4.764746512 |
| Min length | 2 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 256 ? |
|---|---|
| Unique (%) | 0.7% |
Sample
| 1st row | 22-28 |
|---|---|
| 2nd row | 33-23 |
| 3rd row | 25-Jun |
| 4th row | 35-999 |
| 5th row | Feb-37 |
Common Values
| Value | Count | Frequency (%) |
| 42- | 1448 | 1.7% |
| 42-9 | 1139 | 1.3% |
| 27- | 834 | 1.0% |
| 25- | 468 | 0.5% |
| 35-999 | 455 | 0.5% |
| 42-12 | 276 | 0.3% |
| 11- | 275 | 0.3% |
| 30-999 | 267 | 0.3% |
| 18- | 227 | 0.3% |
| 10- | 222 | 0.3% |
| Other values (2373) | 30584 | |
| (Missing) | 49700 |
Length
| Value | Count | Frequency (%) |
| 42 | 1448 | 4.0% |
| 42-9 | 1139 | 3.1% |
| 27 | 835 | 2.3% |
| 25 | 468 | 1.3% |
| 35-999 | 455 | 1.3% |
| 42-12 | 276 | 0.8% |
| 11 | 275 | 0.8% |
| 30-999 | 267 | 0.7% |
| 18 | 227 | 0.6% |
| 10 | 222 | 0.6% |
| Other values (2372) | 30583 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
POLICE DISTRICT
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSING| Distinct | 28 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 54012 |
| Missing (%) | 62.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.52981213 |
| Minimum | 1 |
|---|---|
| Maximum | 181 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 671.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 8 |
| median | 14 |
| Q3 | 19 |
| 95-th percentile | 25 |
| Maximum | 181 |
| Range | 180 |
| Interquartile range (IQR) | 11 |
Descriptive statistics
| Standard deviation | 7.275874386 |
|---|---|
| Coefficient of variation (CV) | 0.5377661063 |
| Kurtosis | 23.74873259 |
| Mean | 13.52981213 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 1.051476098 |
| Sum | 431371 |
| Variance | 52.93834808 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 18 | 3213 | 3.7% |
| 25 | 2665 | 3.1% |
| 19 | 2485 | 2.9% |
| 1 | 2428 | 2.8% |
| 8 | 2295 | 2.7% |
| 12 | 2133 | 2.5% |
| 17 | 2124 | 2.5% |
| 9 | 2069 | 2.4% |
| 16 | 1800 | 2.1% |
| 14 | 1551 | 1.8% |
| Other values (18) | 9120 | 10.6% |
| (Missing) | 54012 |
| Value | Count | Frequency (%) |
| 1 | 2428 | |
| 2 | 582 | 0.7% |
| 3 | 511 | 0.6% |
| 4 | 1108 | |
| 5 | 435 | 0.5% |
| 6 | 703 | 0.8% |
| 7 | 397 | 0.5% |
| 8 | 2295 | |
| 9 | 2069 | |
| 10 | 1461 |
| Value | Count | Frequency (%) |
| 181 | 1 | < 0.1% |
| 161 | 3 | < 0.1% |
| 81 | 1 | < 0.1% |
| 25 | 2665 | |
| 24 | 1163 | |
| 23 | 4 | < 0.1% |
| 22 | 659 | 0.8% |
| 21 | 2 | < 0.1% |
| 20 | 1038 | 1.2% |
| 19 | 2485 |
LICENSE CODE
Real number (ℝ≥0)
| Distinct | 106 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1111.73662 |
| Minimum | 1002 |
|---|---|
| Maximum | 8340 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 671.2 KiB |
Quantile statistics
| Minimum | 1002 |
|---|---|
| 5-th percentile | 1010 |
| Q1 | 1010 |
| median | 1010 |
| Q3 | 1011 |
| 95-th percentile | 1605 |
| Maximum | 8340 |
| Range | 7338 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 250.0208724 |
|---|---|
| Coefficient of variation (CV) | 0.2248921802 |
| Kurtosis | 168.4954244 |
| Mean | 1111.73662 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.442521307 |
| Sum | 95492617 |
| Variance | 62510.43661 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1010 | 50078 | |
| 1011 | 10633 | 12.4% |
| 1604 | 2812 | 3.3% |
| 1012 | 2809 | 3.3% |
| 1006 | 2321 | 2.7% |
| 1525 | 1952 | 2.3% |
| 1605 | 1889 | 2.2% |
| 1676 | 1549 | 1.8% |
| 1008 | 1126 | 1.3% |
| 1020 | 1087 | 1.3% |
| Other values (96) | 9639 | 11.2% |
| Value | Count | Frequency (%) |
| 1002 | 17 | < 0.1% |
| 1004 | 22 | < 0.1% |
| 1005 | 76 | 0.1% |
| 1006 | 2321 | 2.7% |
| 1007 | 127 | 0.1% |
| 1008 | 1126 | 1.3% |
| 1009 | 458 | 0.5% |
| 1010 | 50078 | |
| 1011 | 10633 | 12.4% |
| 1012 | 2809 | 3.3% |
| Value | Count | Frequency (%) |
| 8340 | 1 | < 0.1% |
| 8100 | 22 | < 0.1% |
| 4404 | 4 | < 0.1% |
| 4401 | 8 | < 0.1% |
| 2101 | 7 | < 0.1% |
| 1932 | 60 | 0.1% |
| 1931 | 86 | |
| 1930 | 75 | 0.1% |
| 1900 | 26 | < 0.1% |
| 1842 | 212 |
| Distinct | 106 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 671.2 KiB |
| Limited Business License | |
|---|---|
| Home Repair | |
| Peddler, non-food | 2812 |
| Home Occupation | 2809 |
| Retail Food Establishment | 2321 |
| Other values (101) |
Length
| Max length | 60 |
|---|---|
| Median length | 24 |
| Mean length | 22.05056173 |
| Min length | 5 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 8 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Limited Business License |
|---|---|
| 2nd row | Mobile Food Dispenser |
| 3rd row | Home Repair |
| 4th row | Limited Business License |
| 5th row | Limited Business License |
Common Values
| Value | Count | Frequency (%) |
| Limited Business License | 50078 | |
| Home Repair | 10633 | 12.4% |
| Peddler, non-food | 2812 | 3.3% |
| Home Occupation | 2809 | 3.3% |
| Retail Food Establishment | 2321 | 2.7% |
| Massage Therapist | 1952 | 2.3% |
| Street Performer | 1889 | 2.2% |
| Scavenger, Private | 1549 | 1.8% |
| Hazardous Materials | 1126 | 1.3% |
| Residential Real Estate Developer | 1087 | 1.3% |
| Other values (96) | 9639 | 11.2% |
Length
| Value | Count | Frequency (%) |
| license | 50119 | |
| business | 50082 | |
| limited | 50078 | |
| home | 13442 | 5.4% |
| repair | 12492 | 5.0% |
| peddler | 3834 | 1.5% |
| food | 3570 | 1.4% |
| non-food | 3160 | 1.3% |
| occupation | 2809 | 1.1% |
| 2584 | 1.0% | |
| Other values (184) | 55361 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
LICENSE NUMBER
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 49768 |
|---|---|
| Distinct (%) | 57.9% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1228151.153 |
| Minimum | 129 |
|---|---|
| Maximum | 2391410 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 671.2 KiB |
Quantile statistics
| Minimum | 129 |
|---|---|
| 5-th percentile | 19407.5 |
| Q1 | 87109 |
| median | 1442202 |
| Q3 | 1816581 |
| 95-th percentile | 2129325 |
| Maximum | 2391410 |
| Range | 2391281 |
| Interquartile range (IQR) | 1729472 |
Descriptive statistics
| Standard deviation | 743148.7101 |
|---|---|
| Coefficient of variation (CV) | 0.6050954788 |
| Kurtosis | -0.9916810173 |
| Mean | 1228151.153 |
| Median Absolute Deviation (MAD) | 394408 |
| Skewness | -0.6524057955 |
| Sum | 1.054908152 × 1011 |
| Variance | 5.522700054 × 1011 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 50260 | 13 | < 0.1% |
| 33949 | 13 | < 0.1% |
| 24704 | 12 | < 0.1% |
| 46149 | 12 | < 0.1% |
| 77507 | 12 | < 0.1% |
| 1122772 | 11 | < 0.1% |
| 16833 | 11 | < 0.1% |
| 1167178 | 11 | < 0.1% |
| 58806 | 11 | < 0.1% |
| 37359 | 11 | < 0.1% |
| Other values (49758) | 85777 |
| Value | Count | Frequency (%) |
| 129 | 1 | |
| 130 | 1 | |
| 132 | 1 | |
| 134 | 1 | |
| 135 | 2 | |
| 136 | 1 | |
| 177 | 1 | |
| 184 | 1 | |
| 254 | 1 | |
| 255 | 1 |
| Value | Count | Frequency (%) |
| 2391410 | 1 | |
| 2380107 | 1 | |
| 2353828 | 1 | |
| 2349922 | 1 | |
| 2278462 | 1 | |
| 2270180 | 1 | |
| 2262901 | 1 | |
| 2241060 | 1 | |
| 2225614 | 1 | |
| 2222474 | 1 |
APPLICATION TYPE
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 671.2 KiB |
| RENEW | |
|---|---|
| ISSUE | |
| C_LOC | 1400 |
| C_CAPA | 7 |
| C_EXPA | 5 |
Length
| Max length | 6 |
|---|---|
| Median length | 5 |
| Mean length | 5.000139705 |
| Min length | 5 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | RENEW |
|---|---|
| 2nd row | RENEW |
| 3rd row | ISSUE |
| 4th row | ISSUE |
| 5th row | RENEW |
Common Values
| Value | Count | Frequency (%) |
| RENEW | 61085 | |
| ISSUE | 23398 | 27.2% |
| C_LOC | 1400 | 1.6% |
| C_CAPA | 7 | < 0.1% |
| C_EXPA | 5 | < 0.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| renew | 61085 | |
| issue | 23398 | 27.2% |
| c_loc | 1400 | 1.6% |
| c_capa | 7 | < 0.1% |
| c_expa | 5 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 2899 |
|---|---|
| Distinct (%) | 13.7% |
| Missing | 64660 |
| Missing (%) | 75.3% |
| Memory size | 671.2 KiB |
| 2000-12-18T00:00:00 | 166 |
|---|---|
| 2002-03-27T00:00:00 | 133 |
| 2003-03-25T00:00:00 | 129 |
| 2002-09-24T00:00:00 | 55 |
| 2005-02-14T00:00:00 | 52 |
| Other values (2894) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 178 ? |
|---|---|
| Unique (%) | 0.8% |
Sample
| 1st row | 2009-06-29T00:00:00 |
|---|---|
| 2nd row | 2004-02-10T00:00:00 |
| 3rd row | 2002-01-14T00:00:00 |
| 4th row | 2001-12-13T00:00:00 |
| 5th row | 2010-06-16T00:00:00 |
Common Values
| Value | Count | Frequency (%) |
| 2000-12-18T00:00:00 | 166 | 0.2% |
| 2002-03-27T00:00:00 | 133 | 0.2% |
| 2003-03-25T00:00:00 | 129 | 0.2% |
| 2002-09-24T00:00:00 | 55 | 0.1% |
| 2005-02-14T00:00:00 | 52 | 0.1% |
| 2011-02-22T00:00:00 | 37 | < 0.1% |
| 2005-02-16T00:00:00 | 34 | < 0.1% |
| 2000-07-06T00:00:00 | 32 | < 0.1% |
| 2004-03-10T00:00:00 | 32 | < 0.1% |
| 2003-07-11T00:00:00 | 31 | < 0.1% |
| Other values (2889) | 20534 | 23.9% |
| (Missing) | 64660 |
Length
| Value | Count | Frequency (%) |
| 2000-12-18t00:00:00 | 166 | 0.8% |
| 2002-03-27t00:00:00 | 133 | 0.6% |
| 2003-03-25t00:00:00 | 129 | 0.6% |
| 2002-09-24t00:00:00 | 55 | 0.3% |
| 2005-02-14t00:00:00 | 52 | 0.2% |
| 2011-02-22t00:00:00 | 37 | 0.2% |
| 2005-02-16t00:00:00 | 34 | 0.2% |
| 2000-07-06t00:00:00 | 32 | 0.2% |
| 2004-03-10t00:00:00 | 32 | 0.2% |
| 2003-07-11t00:00:00 | 31 | 0.1% |
| Other values (2889) | 20534 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 3078 |
|---|---|
| Distinct (%) | 3.6% |
| Missing | 214 |
| Missing (%) | 0.2% |
| Memory size | 671.2 KiB |
| 2003-12-15T00:00:00 | 4803 |
|---|---|
| 2006-12-20T00:00:00 | 4281 |
| 2005-12-21T00:00:00 | 4194 |
| 2004-12-20T00:00:00 | 4168 |
| 2002-12-17T00:00:00 | 3751 |
| Other values (3073) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 249 ? |
|---|---|
| Unique (%) | 0.3% |
Sample
| 1st row | 2002-06-28T00:00:00 |
|---|---|
| 2nd row | 2005-09-22T00:00:00 |
| 3rd row | 2009-07-22T00:00:00 |
| 4th row | 2004-02-10T00:00:00 |
| 5th row | 2008-03-24T00:00:00 |
Common Values
| Value | Count | Frequency (%) |
| 2003-12-15T00:00:00 | 4803 | 5.6% |
| 2006-12-20T00:00:00 | 4281 | 5.0% |
| 2005-12-21T00:00:00 | 4194 | 4.9% |
| 2004-12-20T00:00:00 | 4168 | 4.9% |
| 2002-12-17T00:00:00 | 3751 | 4.4% |
| 2001-12-20T00:00:00 | 2720 | 3.2% |
| 2001-12-21T00:00:00 | 987 | 1.1% |
| 2004-06-30T00:00:00 | 900 | 1.0% |
| 2004-09-27T00:00:00 | 748 | 0.9% |
| 2011-02-15T00:00:00 | 724 | 0.8% |
| Other values (3068) | 58405 |
Length
| Value | Count | Frequency (%) |
| 2003-12-15t00:00:00 | 4803 | 5.6% |
| 2006-12-20t00:00:00 | 4281 | 5.0% |
| 2005-12-21t00:00:00 | 4194 | 4.9% |
| 2004-12-20t00:00:00 | 4168 | 4.9% |
| 2002-12-17t00:00:00 | 3751 | 4.4% |
| 2001-12-20t00:00:00 | 2720 | 3.2% |
| 2001-12-21t00:00:00 | 987 | 1.2% |
| 2004-06-30t00:00:00 | 900 | 1.1% |
| 2004-09-27t00:00:00 | 748 | 0.9% |
| 2011-02-15t00:00:00 | 724 | 0.8% |
| Other values (3068) | 58405 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 4356 |
|---|---|
| Distinct (%) | 5.1% |
| Missing | 1289 |
| Missing (%) | 1.5% |
| Memory size | 671.2 KiB |
| 2006-01-23T00:00:00 | 353 |
|---|---|
| 2004-01-20T00:00:00 | 345 |
| 2005-01-19T00:00:00 | 329 |
| 2004-01-12T00:00:00 | 280 |
| 2006-01-30T00:00:00 | 277 |
| Other values (4351) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 487 ? |
|---|---|
| Unique (%) | 0.6% |
Sample
| 1st row | 2002-08-21T00:00:00 |
|---|---|
| 2nd row | 2005-11-03T00:00:00 |
| 3rd row | 2009-07-22T00:00:00 |
| 4th row | 2004-02-10T00:00:00 |
| 5th row | 2008-06-04T00:00:00 |
Common Values
| Value | Count | Frequency (%) |
| 2006-01-23T00:00:00 | 353 | 0.4% |
| 2004-01-20T00:00:00 | 345 | 0.4% |
| 2005-01-19T00:00:00 | 329 | 0.4% |
| 2004-01-12T00:00:00 | 280 | 0.3% |
| 2006-01-30T00:00:00 | 277 | 0.3% |
| 2005-02-07T00:00:00 | 273 | 0.3% |
| 2003-01-13T00:00:00 | 255 | 0.3% |
| 2005-02-14T00:00:00 | 255 | 0.3% |
| 2004-02-13T00:00:00 | 254 | 0.3% |
| 2004-02-17T00:00:00 | 254 | 0.3% |
| Other values (4346) | 81731 | |
| (Missing) | 1289 | 1.5% |
Length
| Value | Count | Frequency (%) |
| 2006-01-23t00:00:00 | 353 | 0.4% |
| 2004-01-20t00:00:00 | 345 | 0.4% |
| 2005-01-19t00:00:00 | 329 | 0.4% |
| 2004-01-12t00:00:00 | 280 | 0.3% |
| 2006-01-30t00:00:00 | 277 | 0.3% |
| 2005-02-07t00:00:00 | 273 | 0.3% |
| 2003-01-13t00:00:00 | 255 | 0.3% |
| 2005-02-14t00:00:00 | 255 | 0.3% |
| 2004-02-13t00:00:00 | 254 | 0.3% |
| 2004-02-17t00:00:00 | 254 | 0.3% |
| Other values (4346) | 81731 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
CONDITIONAL APPROVAL
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 84.0 KiB |
| False | |
|---|---|
| True | 18 |
| Value | Count | Frequency (%) |
| False | 85877 | |
| True | 18 | < 0.1% |
| Distinct | 2825 |
|---|---|
| Distinct (%) | 3.3% |
| Missing | 228 |
| Missing (%) | 0.3% |
| Memory size | 671.2 KiB |
| 2004-02-16T00:00:00 | 5146 |
|---|---|
| 2007-02-16T00:00:00 | 4464 |
| 2006-02-16T00:00:00 | 4432 |
| 2005-02-16T00:00:00 | 4359 |
| 2003-02-16T00:00:00 | 4182 |
| Other values (2820) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 94 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 2002-08-16T00:00:00 |
|---|---|
| 2nd row | 2005-11-16T00:00:00 |
| 3rd row | 2009-07-22T00:00:00 |
| 4th row | 2004-02-11T00:00:00 |
| 5th row | 2008-05-16T00:00:00 |
Common Values
| Value | Count | Frequency (%) |
| 2004-02-16T00:00:00 | 5146 | 6.0% |
| 2007-02-16T00:00:00 | 4464 | 5.2% |
| 2006-02-16T00:00:00 | 4432 | 5.2% |
| 2005-02-16T00:00:00 | 4359 | 5.1% |
| 2003-02-16T00:00:00 | 4182 | 4.9% |
| 2002-02-16T00:00:00 | 3975 | 4.6% |
| 2004-08-16T00:00:00 | 929 | 1.1% |
| 2004-11-16T00:00:00 | 786 | 0.9% |
| 2011-03-16T00:00:00 | 731 | 0.9% |
| 2003-08-16T00:00:00 | 718 | 0.8% |
| Other values (2815) | 55945 |
Length
| Value | Count | Frequency (%) |
| 2004-02-16t00:00:00 | 5146 | 6.0% |
| 2007-02-16t00:00:00 | 4464 | 5.2% |
| 2006-02-16t00:00:00 | 4432 | 5.2% |
| 2005-02-16t00:00:00 | 4359 | 5.1% |
| 2003-02-16t00:00:00 | 4182 | 4.9% |
| 2002-02-16t00:00:00 | 3975 | 4.6% |
| 2004-08-16t00:00:00 | 929 | 1.1% |
| 2004-11-16t00:00:00 | 786 | 0.9% |
| 2011-03-16t00:00:00 | 731 | 0.9% |
| 2003-08-16t00:00:00 | 718 | 0.8% |
| Other values (2815) | 55945 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 297 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 18 |
| Missing (%) | < 0.1% |
| Memory size | 671.2 KiB |
| 2005-02-15T00:00:00 | |
|---|---|
| 2004-02-15T00:00:00 | |
| 2006-02-15T00:00:00 | |
| 2003-02-15T00:00:00 | |
| 2007-02-15T00:00:00 | |
| Other values (292) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 102 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 2003-08-15T00:00:00 |
|---|---|
| 2nd row | 2006-11-15T00:00:00 |
| 3rd row | 2011-07-15T00:00:00 |
| 4th row | 2005-02-15T00:00:00 |
| 5th row | 2010-05-15T00:00:00 |
Common Values
| Value | Count | Frequency (%) |
| 2005-02-15T00:00:00 | 7162 | 8.3% |
| 2004-02-15T00:00:00 | 6368 | 7.4% |
| 2006-02-15T00:00:00 | 6024 | 7.0% |
| 2003-02-15T00:00:00 | 5947 | 6.9% |
| 2007-02-15T00:00:00 | 5893 | 6.9% |
| 2013-04-15T00:00:00 | 1139 | 1.3% |
| 2013-03-15T00:00:00 | 1036 | 1.2% |
| 2005-11-15T00:00:00 | 974 | 1.1% |
| 2013-05-15T00:00:00 | 963 | 1.1% |
| 2013-11-15T00:00:00 | 944 | 1.1% |
| Other values (287) | 49427 |
Length
| Value | Count | Frequency (%) |
| 2005-02-15t00:00:00 | 7162 | 8.3% |
| 2004-02-15t00:00:00 | 6368 | 7.4% |
| 2006-02-15t00:00:00 | 6024 | 7.0% |
| 2003-02-15t00:00:00 | 5947 | 6.9% |
| 2007-02-15t00:00:00 | 5893 | 6.9% |
| 2013-04-15t00:00:00 | 1139 | 1.3% |
| 2013-03-15t00:00:00 | 1036 | 1.2% |
| 2005-11-15t00:00:00 | 974 | 1.1% |
| 2013-05-15t00:00:00 | 963 | 1.1% |
| 2013-11-15t00:00:00 | 944 | 1.1% |
| Other values (287) | 49427 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 4223 |
|---|---|
| Distinct (%) | 5.3% |
| Missing | 6789 |
| Missing (%) | 7.9% |
| Memory size | 671.2 KiB |
| 2003-12-22T00:00:00 | 4833 |
|---|---|
| 2006-01-23T00:00:00 | 320 |
| 2005-01-19T00:00:00 | 294 |
| 2006-01-30T00:00:00 | 243 |
| 2003-01-13T00:00:00 | 221 |
| Other values (4218) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 419 ? |
|---|---|
| Unique (%) | 0.5% |
Sample
| 1st row | 2002-08-21T00:00:00 |
|---|---|
| 2nd row | 2006-04-05T00:00:00 |
| 3rd row | 2009-07-22T00:00:00 |
| 4th row | 2004-02-10T00:00:00 |
| 5th row | 2008-06-04T00:00:00 |
Common Values
| Value | Count | Frequency (%) |
| 2003-12-22T00:00:00 | 4833 | 5.6% |
| 2006-01-23T00:00:00 | 320 | 0.4% |
| 2005-01-19T00:00:00 | 294 | 0.3% |
| 2006-01-30T00:00:00 | 243 | 0.3% |
| 2003-01-13T00:00:00 | 221 | 0.3% |
| 2005-02-07T00:00:00 | 211 | 0.2% |
| 2005-02-14T00:00:00 | 208 | 0.2% |
| 2007-01-16T00:00:00 | 201 | 0.2% |
| 2006-02-23T00:00:00 | 199 | 0.2% |
| 2003-01-21T00:00:00 | 190 | 0.2% |
| Other values (4213) | 72186 | |
| (Missing) | 6789 | 7.9% |
Length
| Value | Count | Frequency (%) |
| 2003-12-22t00:00:00 | 4833 | 6.1% |
| 2006-01-23t00:00:00 | 320 | 0.4% |
| 2005-01-19t00:00:00 | 294 | 0.4% |
| 2006-01-30t00:00:00 | 243 | 0.3% |
| 2003-01-13t00:00:00 | 221 | 0.3% |
| 2005-02-07t00:00:00 | 211 | 0.3% |
| 2005-02-14t00:00:00 | 208 | 0.3% |
| 2007-01-16t00:00:00 | 201 | 0.3% |
| 2006-02-23t00:00:00 | 199 | 0.3% |
| 2003-01-21t00:00:00 | 190 | 0.2% |
| Other values (4213) | 72186 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 3498 |
|---|---|
| Distinct (%) | 4.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 671.2 KiB |
| 2003-12-22T00:00:00 | 566 |
|---|---|
| 2003-02-21T00:00:00 | 407 |
| 2004-01-21T00:00:00 | 365 |
| 2006-01-24T00:00:00 | 311 |
| 2005-01-20T00:00:00 | 274 |
| Other values (3493) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 89 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 2006-04-11T00:00:00 |
|---|---|
| 2nd row | 2006-06-12T00:00:00 |
| 3rd row | 2009-07-22T00:00:00 |
| 4th row | 2004-02-11T00:00:00 |
| 5th row | 2008-06-05T00:00:00 |
Common Values
| Value | Count | Frequency (%) |
| 2003-12-22T00:00:00 | 566 | 0.7% |
| 2003-02-21T00:00:00 | 407 | 0.5% |
| 2004-01-21T00:00:00 | 365 | 0.4% |
| 2006-01-24T00:00:00 | 311 | 0.4% |
| 2005-01-20T00:00:00 | 274 | 0.3% |
| 2004-01-13T00:00:00 | 245 | 0.3% |
| 2006-01-31T00:00:00 | 239 | 0.3% |
| 2002-01-22T00:00:00 | 231 | 0.3% |
| 2004-02-17T00:00:00 | 218 | 0.3% |
| 2005-02-08T00:00:00 | 208 | 0.2% |
| Other values (3488) | 82831 |
Length
| Value | Count | Frequency (%) |
| 2003-12-22t00:00:00 | 566 | 0.7% |
| 2003-02-21t00:00:00 | 407 | 0.5% |
| 2004-01-21t00:00:00 | 365 | 0.4% |
| 2006-01-24t00:00:00 | 311 | 0.4% |
| 2005-01-20t00:00:00 | 274 | 0.3% |
| 2004-01-13t00:00:00 | 245 | 0.3% |
| 2006-01-31t00:00:00 | 239 | 0.3% |
| 2002-01-22t00:00:00 | 231 | 0.3% |
| 2004-02-17t00:00:00 | 218 | 0.3% |
| 2005-02-08t00:00:00 | 208 | 0.2% |
| Other values (3488) | 82831 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 3152 |
|---|---|
| Distinct (%) | 10.3% |
| Missing | 55400 |
| Missing (%) | 64.5% |
| Memory size | 671.2 KiB |
| 2012-12-29T00:00:00 | |
|---|---|
| 2005-01-03T00:00:00 | 1069 |
| 2012-12-31T00:00:00 | 770 |
| 2003-04-02T00:00:00 | 358 |
| 2012-08-06T00:00:00 | 342 |
| Other values (3147) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 477 ? |
|---|---|
| Unique (%) | 1.6% |
Sample
| 1st row | 2006-06-15T00:00:00 |
|---|---|
| 2nd row | 2004-05-04T00:00:00 |
| 3rd row | 2007-03-09T00:00:00 |
| 4th row | 2008-07-28T00:00:00 |
| 5th row | 2012-08-07T00:00:00 |
Common Values
| Value | Count | Frequency (%) |
| 2012-12-29T00:00:00 | 10060 | 11.7% |
| 2005-01-03T00:00:00 | 1069 | 1.2% |
| 2012-12-31T00:00:00 | 770 | 0.9% |
| 2003-04-02T00:00:00 | 358 | 0.4% |
| 2012-08-06T00:00:00 | 342 | 0.4% |
| 2013-07-01T00:00:00 | 297 | 0.3% |
| 2012-08-03T00:00:00 | 265 | 0.3% |
| 2012-08-07T00:00:00 | 184 | 0.2% |
| 2012-08-31T00:00:00 | 160 | 0.2% |
| 2012-04-10T00:00:00 | 130 | 0.2% |
| Other values (3142) | 16860 | 19.6% |
| (Missing) | 55400 |
Length
| Value | Count | Frequency (%) |
| 2012-12-29t00:00:00 | 10060 | |
| 2005-01-03t00:00:00 | 1069 | 3.5% |
| 2012-12-31t00:00:00 | 770 | 2.5% |
| 2003-04-02t00:00:00 | 358 | 1.2% |
| 2012-08-06t00:00:00 | 342 | 1.1% |
| 2013-07-01t00:00:00 | 297 | 1.0% |
| 2012-08-03t00:00:00 | 265 | 0.9% |
| 2012-08-07t00:00:00 | 184 | 0.6% |
| 2012-08-31t00:00:00 | 160 | 0.5% |
| 2012-04-10t00:00:00 | 130 | 0.4% |
| Other values (3142) | 16860 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 53 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 76446 |
| Missing (%) | 89.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 29.15207959 |
| Minimum | 1 |
|---|---|
| Maximum | 69 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 671.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 17 |
| median | 28 |
| Q3 | 40 |
| 95-th percentile | 60 |
| Maximum | 69 |
| Range | 68 |
| Interquartile range (IQR) | 23 |
Descriptive statistics
| Standard deviation | 17.41989791 |
|---|---|
| Coefficient of variation (CV) | 0.5975524956 |
| Kurtosis | -0.7530328653 |
| Mean | 29.15207959 |
| Median Absolute Deviation (MAD) | 11 |
| Skewness | 0.231884087 |
| Sum | 275458 |
| Variance | 303.4528431 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 33 | 542 | 0.6% |
| 3 | 463 | 0.5% |
| 60 | 458 | 0.5% |
| 34 | 378 | 0.4% |
| 8 | 374 | 0.4% |
| 1 | 365 | 0.4% |
| 27 | 358 | 0.4% |
| 17 | 357 | 0.4% |
| 13 | 353 | 0.4% |
| 25 | 330 | 0.4% |
| Other values (43) | 5471 | 6.4% |
| (Missing) | 76446 |
| Value | Count | Frequency (%) |
| 1 | 365 | |
| 2 | 113 | 0.1% |
| 3 | 463 | |
| 4 | 63 | 0.1% |
| 5 | 88 | 0.1% |
| 7 | 59 | 0.1% |
| 8 | 374 | |
| 10 | 262 | |
| 13 | 353 | |
| 14 | 108 | 0.1% |
| Value | Count | Frequency (%) |
| 69 | 75 | 0.1% |
| 64 | 10 | < 0.1% |
| 63 | 64 | 0.1% |
| 62 | 40 | < 0.1% |
| 61 | 100 | 0.1% |
| 60 | 458 | |
| 59 | 175 | 0.2% |
| 56 | 50 | 0.1% |
| 55 | 47 | 0.1% |
| 54 | 54 | 0.1% |
LATITUDE
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSING| Distinct | 21373 |
|---|---|
| Distinct (%) | 55.3% |
| Missing | 47246 |
| Missing (%) | 55.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 41.88095213 |
| Minimum | 41.64469419 |
|---|---|
| Maximum | 42.02266027 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 671.2 KiB |
Quantile statistics
| Minimum | 41.64469419 |
|---|---|
| 5-th percentile | 41.72724059 |
| Q1 | 41.83431211 |
| median | 41.89267922 |
| Q3 | 41.93862431 |
| 95-th percentile | 41.99230124 |
| Maximum | 42.02266027 |
| Range | 0.37796608 |
| Interquartile range (IQR) | 0.1043122 |
Descriptive statistics
| Standard deviation | 0.07961676768 |
|---|---|
| Coefficient of variation (CV) | 0.001901025732 |
| Kurtosis | -0.1688601576 |
| Mean | 41.88095213 |
| Median Absolute Deviation (MAD) | 0.0479852 |
| Skewness | -0.6701842091 |
| Sum | 1618656.919 |
| Variance | 0.006338829696 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 41.90872856 | 538 | 0.6% |
| 41.85761689 | 230 | 0.3% |
| 41.89224916 | 141 | 0.2% |
| 41.88807428 | 123 | 0.1% |
| 41.81944143 | 97 | 0.1% |
| 41.75466012 | 86 | 0.1% |
| 41.89000134 | 71 | 0.1% |
| 41.84451147 | 67 | 0.1% |
| 41.85287169 | 65 | 0.1% |
| 41.89209414 | 64 | 0.1% |
| Other values (21363) | 37167 | |
| (Missing) | 47246 |
| Value | Count | Frequency (%) |
| 41.64469419 | 1 | < 0.1% |
| 41.64471544 | 1 | < 0.1% |
| 41.64471652 | 1 | < 0.1% |
| 41.64471655 | 8 | |
| 41.64471662 | 9 | |
| 41.64472134 | 5 | |
| 41.64474617 | 9 | |
| 41.64479807 | 1 | < 0.1% |
| 41.64566748 | 1 | < 0.1% |
| 41.64637082 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 42.02266027 | 1 | |
| 42.0224802 | 1 | |
| 42.0221232 | 1 | |
| 42.02201732 | 1 | |
| 42.02144853 | 1 | |
| 42.02131765 | 1 | |
| 42.02126168 | 1 | |
| 42.02008732 | 1 | |
| 42.02002619 | 1 | |
| 42.01986688 | 1 |
| Distinct | 21380 |
|---|---|
| Distinct (%) | 55.3% |
| Missing | 47246 |
| Missing (%) | 55.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -87.68116527 |
| Minimum | -87.915285 |
|---|---|
| Maximum | -87.5258717 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 38649 |
| Negative (%) | 45.0% |
| Memory size | 671.2 KiB |
Quantile statistics
| Minimum | -87.915285 |
|---|---|
| 5-th percentile | -87.77860152 |
| Q1 | -87.71915015 |
| median | -87.67332082 |
| Q3 | -87.63950931 |
| 95-th percentile | -87.60489691 |
| Maximum | -87.5258717 |
| Range | 0.3894133 |
| Interquartile range (IQR) | 0.07964084 |
Descriptive statistics
| Standard deviation | 0.05624772088 |
|---|---|
| Coefficient of variation (CV) | -0.0006415028895 |
| Kurtosis | 0.5405340645 |
| Mean | -87.68116527 |
| Median Absolute Deviation (MAD) | 0.03818322 |
| Skewness | -0.4623129673 |
| Sum | -3388789.357 |
| Variance | 0.003163806104 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -87.65472645 | 538 | 0.6% |
| -87.63607109 | 230 | 0.3% |
| -87.60951805 | 141 | 0.2% |
| -87.6349552 | 123 | 0.1% |
| -87.66537555 | 97 | 0.1% |
| -87.74138476 | 86 | 0.1% |
| -87.62143869 | 71 | 0.1% |
| -87.67578804 | 67 | 0.1% |
| -87.64056366 | 65 | 0.1% |
| -87.61156988 | 64 | 0.1% |
| Other values (21370) | 37167 | |
| (Missing) | 47246 |
| Value | Count | Frequency (%) |
| -87.915285 | 11 | < 0.1% |
| -87.91453383 | 12 | < 0.1% |
| -87.91452685 | 1 | < 0.1% |
| -87.91446851 | 6 | < 0.1% |
| -87.91443585 | 9 | < 0.1% |
| -87.91442844 | 48 | |
| -87.90232236 | 4 | < 0.1% |
| -87.89421319 | 2 | < 0.1% |
| -87.89131942 | 4 | < 0.1% |
| -87.88582302 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| -87.5258717 | 1 | |
| -87.52663573 | 1 | |
| -87.52666538 | 1 | |
| -87.52682279 | 1 | |
| -87.52686804 | 1 | |
| -87.52716006 | 2 | |
| -87.527593 | 2 | |
| -87.52770401 | 2 | |
| -87.52781934 | 1 | |
| -87.52809039 | 1 |
| Distinct | 21388 |
|---|---|
| Distinct (%) | 55.3% |
| Missing | 47246 |
| Missing (%) | 55.0% |
| Memory size | 671.2 KiB |
| {'latitude': '41.90872856223717', 'longitude': '-87.6547264445884', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}'} | 538 |
|---|---|
| {'latitude': '41.85761688731556', 'longitude': '-87.63607109247158', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}'} | 230 |
| {'latitude': '41.892249163400116', 'longitude': '-87.60951804879336', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}'} | 141 |
| {'latitude': '41.8880742810662', 'longitude': '-87.63495520292739', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}'} | 123 |
| {'latitude': '41.81944142629576', 'longitude': '-87.6653755449091', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}'} | 97 |
| Other values (21383) |
Length
| Max length | 159 |
|---|---|
| Median length | 158 |
| Mean length | 158.0508939 |
| Min length | 153 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 15280 ? |
|---|---|
| Unique (%) | 39.5% |
Sample
| 1st row | {'latitude': '41.843612879431845', 'longitude': '-87.71461847216574', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}'} |
|---|---|
| 2nd row | {'latitude': '41.96113244107215', 'longitude': '-87.69962604438346', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}'} |
| 3rd row | {'latitude': '41.856222490735874', 'longitude': '-87.6390323692093', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}'} |
| 4th row | {'latitude': '41.92437507335029', 'longitude': '-87.72670493056832', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}'} |
| 5th row | {'latitude': '41.9232444111139', 'longitude': '-87.66645762597676', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}'} |
Common Values
| Value | Count | Frequency (%) |
| {'latitude': '41.90872856223717', 'longitude': '-87.6547264445884', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}'} | 538 | 0.6% |
| {'latitude': '41.85761688731556', 'longitude': '-87.63607109247158', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}'} | 230 | 0.3% |
| {'latitude': '41.892249163400116', 'longitude': '-87.60951804879336', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}'} | 141 | 0.2% |
| {'latitude': '41.8880742810662', 'longitude': '-87.63495520292739', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}'} | 123 | 0.1% |
| {'latitude': '41.81944142629576', 'longitude': '-87.6653755449091', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}'} | 97 | 0.1% |
| {'latitude': '41.75466012439374', 'longitude': '-87.74138475860521', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}'} | 86 | 0.1% |
| {'latitude': '41.890001335214684', 'longitude': '-87.62143868830125', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}'} | 71 | 0.1% |
| {'latitude': '41.844511469065175', 'longitude': '-87.67578803912177', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}'} | 67 | 0.1% |
| {'latitude': '41.852871687739125', 'longitude': '-87.64056365490387', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}'} | 65 | 0.1% |
| {'latitude': '41.892094136861786', 'longitude': '-87.61156988394656', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}'} | 64 | 0.1% |
| Other values (21378) | 37167 | |
| (Missing) | 47246 |
Length
| Value | Count | Frequency (%) |
| latitude | 38649 | |
| human_address | 38649 | |
| longitude | 38649 | |
| address":"","city":"","state":"","zip | 38649 | |
| needs_recoding | 38649 | |
| false | 38649 | |
| 41.90872856223717 | 538 | 0.2% |
| 87.6547264445884 | 538 | 0.2% |
| 41.85761688731556 | 230 | 0.1% |
| 87.63607109247158 | 230 | 0.1% |
| Other values (42772) | 75762 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 671.2 KiB |
| AAI | |
|---|---|
| AAC | |
| REV | 290 |
| REA | 3 |
| INQ | 2 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | AAI |
|---|---|
| 2nd row | AAC |
| 3rd row | AAI |
| 4th row | AAI |
| 5th row | AAI |
Common Values
| Value | Count | Frequency (%) |
| AAI | 55400 | |
| AAC | 30200 | |
| REV | 290 | 0.3% |
| REA | 3 | < 0.1% |
| INQ | 2 | < 0.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| aai | 55400 | |
| aac | 30200 | |
| rev | 290 | 0.3% |
| rea | 3 | < 0.1% |
| inq | 2 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| ID | LICENSE ID | ACCOUNT NUMBER | SITE NUMBER | LEGAL NAME | DOING BUSINESS AS NAME | ADDRESS | CITY | STATE | ZIP CODE | WARD | PRECINCT | WARD PRECINCT | POLICE DISTRICT | LICENSE CODE | LICENSE DESCRIPTION | LICENSE NUMBER | APPLICATION TYPE | APPLICATION CREATED DATE | APPLICATION REQUIREMENTS COMPLETE | PAYMENT DATE | CONDITIONAL APPROVAL | LICENSE TERM START DATE | LICENSE TERM EXPIRATION DATE | LICENSE APPROVED FOR ISSUANCE | DATE ISSUED | LICENSE STATUS CHANGE DATE | SSA | LATITUDE | LONGITUDE | LOCATION | LICENSE STATUS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 35342-20020816 | 1256593 | 32811 | 1 | CARMEN CAHUE | CLAUDIA'S BRIDAL SHOP | 2625 S CENTRAL PARK AVE 1 | CHICAGO | IL | 60623 | 22.0 | 28.0 | 22-28 | 10.0 | 1010 | Limited Business License | 35342.0 | RENEW | NaN | 2002-06-28T00:00:00 | 2002-08-21T00:00:00 | N | 2002-08-16T00:00:00 | 2003-08-15T00:00:00 | 2002-08-21T00:00:00 | 2006-04-11T00:00:00 | NaN | 25.0 | 41.843613 | -87.714618 | {'latitude': '41.843612879431845', 'longitude': '-87.71461847216574', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}'} | AAI |
| 1 | 1358463-20051116 | 1639294 | 262311 | 29 | ISLA TROPICAL, INC. | ISLA TROPICAL | 2825 W MONTROSE AVE | CHICAGO | IL | 60618 | 33.0 | 23.0 | 33-23 | 17.0 | 1315 | Mobile Food Dispenser | 1358463.0 | RENEW | NaN | 2005-09-22T00:00:00 | 2005-11-03T00:00:00 | N | 2005-11-16T00:00:00 | 2006-11-15T00:00:00 | 2006-04-05T00:00:00 | 2006-06-12T00:00:00 | 2006-06-15T00:00:00 | 60.0 | 41.961132 | -87.699626 | {'latitude': '41.96113244107215', 'longitude': '-87.69962604438346', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}'} | AAC |
| 2 | 1980233-20090722 | 1980233 | 345008 | 1 | DJS REMODELING | DJS REMODELING, INC. | 1605 CLAVEY RD 1 | HIGHLAND | IL | 60035 | NaN | NaN | NaN | NaN | 1011 | Home Repair | 1980233.0 | ISSUE | 2009-06-29T00:00:00 | 2009-07-22T00:00:00 | 2009-07-22T00:00:00 | N | 2009-07-22T00:00:00 | 2011-07-15T00:00:00 | 2009-07-22T00:00:00 | 2009-07-22T00:00:00 | NaN | NaN | NaN | NaN | NaN | AAI |
| 3 | 1476582-20040211 | 1476582 | 273121 | 1 | ALL-BRY CONSTRUCTION CO. | ALL-BRY CONSTRUCTION CO. | 8 NORTH TRAIL | LEMONT | IL | 60439 | NaN | NaN | NaN | NaN | 1010 | Limited Business License | 1476582.0 | ISSUE | 2004-02-10T00:00:00 | 2004-02-10T00:00:00 | 2004-02-10T00:00:00 | N | 2004-02-11T00:00:00 | 2005-02-15T00:00:00 | 2004-02-10T00:00:00 | 2004-02-11T00:00:00 | NaN | NaN | NaN | NaN | NaN | AAI |
| 4 | 1141408-20080516 | 1896750 | 213785 | 1 | MCDONOUGH MECHANICAL SERVICE | MCDONOUGH MECHANICAL SERVICE | 4081 JOSEPH DR | WAUKEGAN | IL | 60087 | NaN | NaN | NaN | NaN | 1010 | Limited Business License | 1141408.0 | RENEW | NaN | 2008-03-24T00:00:00 | 2008-06-04T00:00:00 | N | 2008-05-16T00:00:00 | 2010-05-15T00:00:00 | 2008-06-04T00:00:00 | 2008-06-05T00:00:00 | NaN | NaN | NaN | NaN | NaN | AAI |
| 5 | 2129534-20111129 | 2129534 | 368042 | 1 | QUALITY PLUMBING SERVICES INC. | QUALITY PLUMBING SERVICES INC. | 251 OAKWOOD DR | WOOD DALE | IL | 60191 | NaN | NaN | NaN | NaN | 1010 | Limited Business License | 2129534.0 | ISSUE | NaN | 2011-11-28T00:00:00 | 2011-11-28T00:00:00 | N | 2011-11-29T00:00:00 | 2013-12-15T00:00:00 | 2011-11-28T00:00:00 | 2011-11-29T00:00:00 | NaN | NaN | NaN | NaN | NaN | AAI |
| 6 | 1275083-20040216 | 1455178 | 36211 | 2 | FELIX BARRERA | BARRERA CONSTRUCTION | 318 N FOREST | HILLSIDE | IL | 60162 | NaN | NaN | NaN | NaN | 1010 | Limited Business License | 1275083.0 | RENEW | NaN | 2003-12-15T00:00:00 | 2005-02-15T00:00:00 | N | 2004-02-16T00:00:00 | 2005-02-15T00:00:00 | 2003-12-22T00:00:00 | 2005-02-15T00:00:00 | NaN | NaN | NaN | NaN | NaN | AAI |
| 7 | 1223497-20030816 | 1375248 | 230124 | 1 | INTERSTATE MECHANICAL & CONSTRUCTION INC | INTERSTATE MECHANICAL & CONSTRUCTION INC | 1850 S CANAL ST | CHICAGO | IL | 60616 | 25.0 | 6.0 | 25-Jun | 12.0 | 1010 | Limited Business License | 1223497.0 | RENEW | NaN | 2003-06-24T00:00:00 | 2003-08-06T00:00:00 | N | 2003-08-16T00:00:00 | 2004-08-15T00:00:00 | 2003-08-06T00:00:00 | 2003-08-07T00:00:00 | 2004-05-04T00:00:00 | NaN | 41.856222 | -87.639032 | {'latitude': '41.856222490735874', 'longitude': '-87.6390323692093', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}'} | AAC |
| 8 | 1222096-20020124 | 1222096 | 223263 | 1 | LESLIE LOCKETT | DELUXE CUSTOM SERVICES | 20132 DOLPHIN AVE | LYNWOOD | IL | 60411 | NaN | NaN | NaN | NaN | 1011 | Home Repair | 1222096.0 | ISSUE | 2002-01-14T00:00:00 | 2002-01-23T00:00:00 | 2002-01-23T00:00:00 | N | 2002-01-24T00:00:00 | 2003-02-15T00:00:00 | 2002-01-24T00:00:00 | 2002-01-24T00:00:00 | NaN | NaN | NaN | NaN | NaN | AAI |
| 9 | 1197714-20020809 | 1197714 | 86252 | 3 | JOY CHEMMACHEL | FULLERTON PULASKI SHELL | 3959 W FULLERTON AVE 1 | CHICAGO | IL | 60647 | 35.0 | 999.0 | 35-999 | 25.0 | 1569 | Motor Vehicle Repair : Engine Only (Class II) | 1197714.0 | ISSUE | 2001-12-13T00:00:00 | 2002-01-16T00:00:00 | 2002-01-16T00:00:00 | N | 2002-08-09T00:00:00 | 2002-08-15T00:00:00 | 2002-02-05T00:00:00 | 2002-07-17T00:00:00 | NaN | NaN | 41.924375 | -87.726705 | {'latitude': '41.92437507335029', 'longitude': '-87.72670493056832', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}'} | AAI |
Last rows
| ID | LICENSE ID | ACCOUNT NUMBER | SITE NUMBER | LEGAL NAME | DOING BUSINESS AS NAME | ADDRESS | CITY | STATE | ZIP CODE | WARD | PRECINCT | WARD PRECINCT | POLICE DISTRICT | LICENSE CODE | LICENSE DESCRIPTION | LICENSE NUMBER | APPLICATION TYPE | APPLICATION CREATED DATE | APPLICATION REQUIREMENTS COMPLETE | PAYMENT DATE | CONDITIONAL APPROVAL | LICENSE TERM START DATE | LICENSE TERM EXPIRATION DATE | LICENSE APPROVED FOR ISSUANCE | DATE ISSUED | LICENSE STATUS CHANGE DATE | SSA | LATITUDE | LONGITUDE | LOCATION | LICENSE STATUS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 85885 | 86333-20020216 | 1214630 | 81680 | 2 | WIESLAW WOLOSZYN | W. W. PERFECT CO. | 6780 W FOREST PRESERVE 1ST | HARWOOD HEIGHTS | IL | 60706 | NaN | NaN | NaN | NaN | 1011 | Home Repair | 86333.0 | RENEW | NaN | 2001-12-20T00:00:00 | 2002-02-07T00:00:00 | N | 2002-02-16T00:00:00 | 2003-02-15T00:00:00 | 2002-05-21T00:00:00 | 2002-05-21T00:00:00 | NaN | NaN | 41.959139 | -87.796520 | {'latitude': '41.95913901863654', 'longitude': '-87.79652050021537', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}'} | AAI |
| 85886 | 1645808-20060216 | 1674594 | 296566 | 1 | FANCY PAWS | FANCY PAWS | 2040 BRITANY BEND | LAKE IN THE HILLS | IL | 60156 | NaN | NaN | NaN | NaN | 1010 | Limited Business License | 1645808.0 | RENEW | NaN | 2005-12-21T00:00:00 | 2006-02-15T00:00:00 | N | 2006-02-16T00:00:00 | 2007-02-15T00:00:00 | 2006-02-15T00:00:00 | 2006-02-16T00:00:00 | NaN | NaN | NaN | NaN | NaN | AAI |
| 85887 | 2078674-20130116 | 2201064 | 313978 | 2 | EDILBERTO SERRANO PEREZ | E & S LANDSCAPING | 1208 LINCOLN AVE | ROCKFORD | IL | 61102 | NaN | NaN | NaN | NaN | 1010 | Limited Business License | 2078674.0 | RENEW | NaN | 2012-11-15T00:00:00 | 2013-01-08T00:00:00 | N | 2013-01-16T00:00:00 | 2015-01-15T00:00:00 | 2013-01-08T00:00:00 | 2013-01-09T00:00:00 | NaN | NaN | NaN | NaN | NaN | AAI |
| 85888 | 3361-20050816 | 1608234 | 85406 | 1 | CHICAGO TUBE & IRON CO | CHICAGO TUBE & IRON CO | 1 CHICAGO TUBE DR | ROMEOVILLE | IL | 60446 | NaN | NaN | NaN | NaN | 1010 | Limited Business License | 3361.0 | RENEW | NaN | 2005-06-21T00:00:00 | 2005-07-11T00:00:00 | N | 2005-08-16T00:00:00 | 2006-08-15T00:00:00 | 2005-07-11T00:00:00 | 2005-07-12T00:00:00 | NaN | NaN | NaN | NaN | NaN | AAI |
| 85889 | 1245994-20030216 | 1322417 | 204267 | 2 | HAYWARD BAKER INC. | Hayward Baker Inc. | 1477 BARCLAY BLVD | BUFFALO GROVE | IL | 60089 | NaN | NaN | NaN | NaN | 1010 | Limited Business License | 1245994.0 | RENEW | NaN | 2002-12-17T00:00:00 | 2003-02-06T00:00:00 | N | 2003-02-16T00:00:00 | 2004-02-15T00:00:00 | 2003-02-06T00:00:00 | 2003-02-07T00:00:00 | NaN | NaN | NaN | NaN | NaN | AAI |
| 85890 | 12652-20120516 | 2143400 | 8011 | 1 | UNITED PARCEL SERVICE | UNITED PARCEL SERVICE | 1400 S JEFFERSON ST | CHICAGO | IL | 60607 | 11.0 | 28.0 | Nov-28 | 1.0 | 1008 | Hazardous Materials | 12652.0 | RENEW | NaN | 2012-03-15T00:00:00 | 2012-05-07T00:00:00 | N | 2012-05-16T00:00:00 | 2014-05-15T00:00:00 | 2012-05-07T00:00:00 | 2012-05-08T00:00:00 | 2012-12-29T00:00:00 | NaN | 41.863501 | -87.642210 | {'latitude': '41.86350135244771', 'longitude': '-87.64220950077579', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}'} | AAC |
| 85891 | 1821421-20070522 | 1821421 | 317725 | 1 | EXPRESS BOARD UP SERVICE, INC. | EXPRESS BOARD UP SERVICE, INC. | 8707 VANGUARD DR | MACHESNEY PARK | IL | 61115 | NaN | NaN | NaN | NaN | 1800 | Board-Up Work | 1821421.0 | ISSUE | 2007-05-21T00:00:00 | 2007-05-22T00:00:00 | 2007-05-22T00:00:00 | N | 2007-05-22T00:00:00 | 2009-06-15T00:00:00 | 2007-05-22T00:00:00 | 2007-05-22T00:00:00 | NaN | NaN | NaN | NaN | NaN | AAI |
| 85892 | 74137-20090116 | 1939358 | 8458 | 2 | ARAMARK SMMS LLC | ARAMARK FACILITY SERVICES | 2300 WARRENVILLE RD 1ST | DOWNERS GROVE | IL | 60515 | NaN | NaN | NaN | NaN | 1010 | Limited Business License | 74137.0 | RENEW | NaN | 2008-11-14T00:00:00 | 2009-01-09T00:00:00 | N | 2009-01-16T00:00:00 | 2011-01-15T00:00:00 | 2009-01-09T00:00:00 | 2009-12-08T00:00:00 | NaN | NaN | NaN | NaN | NaN | AAI |
| 85893 | 2049545-20111016 | 2110060 | 2156 | 43 | GENERAL NUTRITION CORPORATION | GENERAL NUTRITION CENTER # 61 | 5151 S PULASKI RD SLAB ON GRADE T-21 | CHICAGO | IL | 60632 | 23.0 | NaN | 23- | NaN | 1010 | Limited Business License | 2049545.0 | RENEW | NaN | 2011-08-15T00:00:00 | 2011-10-03T00:00:00 | N | 2011-10-16T00:00:00 | 2013-10-15T00:00:00 | 2011-10-03T00:00:00 | 2011-10-11T00:00:00 | 2012-05-08T00:00:00 | NaN | 41.799012 | -87.723181 | {'latitude': '41.79901235310339', 'longitude': '-87.72318127025324', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}'} | AAC |
| 85894 | 1070196-20040216 | 1461628 | 205936 | 1 | JUAN CARLOS ERAZO | CASA DE JUAN RESTAURANT | 5814 W FULLERTON AVE | CHICAGO | IL | 60639 | 30.0 | 52.0 | 30-52 | 25.0 | 1006 | Retail Food Establishment | 1070196.0 | RENEW | NaN | 2003-12-15T00:00:00 | 2004-02-06T00:00:00 | N | 2004-02-16T00:00:00 | 2005-02-15T00:00:00 | 2003-12-22T00:00:00 | 2004-02-09T00:00:00 | 2005-01-07T00:00:00 | NaN | 41.924004 | -87.771507 | {'latitude': '41.92400390449922', 'longitude': '-87.77150683710967', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}'} | AAC |